using System;
using System.Collections.Generic;
using System.Text;
using System.Data;

using KioskViewerBLL.BLLObjects;
using KioskViewerDAL.DataObjects;

// KioskViewerDAL.SqlServer 

namespace KioskViewerDAL.SqlServer
{
    /// <summary>
    /// Sql Server specific data access object that handles data access
    /// of customers.
    /// </summary>
    public class SqlServerCategory : ICategory
    {

        public IList<CategoryObj> GetAll_category()
        {
            string sErr = "";
            IList<CategoryObj> list = new List<CategoryObj>();
            IDataReader dr = Untils.ExecuteReaderEx("SELECT * FROM [vw_kioskviewer_category] ORDER BY sort", ref sErr);
            //if (sErr != string.Empty) return list;
            if (dr != null) list = CBO.FillCollection(dr, ref list);
            return list;
        }       
    }
}
